1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class NhapNhanhMod
15 {
16 protected int IdNhapNhanh { get; set; }
17 protected string MaSanPham { get; set; }
18 protected string MaVietTat { get; set; }
19 protected string TenSanPham { get; set; }
20 protected string TenDonViTinh { get; set; }
21 protected double SoLuong { get; set; }
22 protected double GiaNhap { get; set; }
23 protected double ChietKhau { get; set; }
24 protected double Thue { get; set; }
25 protected double TongTien { get; set; }
26 protected int NhapHangId { get; set; }
27 protected string TrangThai { get; set; }
28 protected DateTime NgayTao { get; set; }
29
30
31 public NhapNhanhMod(int _IdNhapNhanh)
32 {
33 IdNhapNhanh = _IdNhapNhanh;
34 }
35
36
37 public NhapNhanhMod()
38 {
39
40 }
41
42 public NhapNhanhMod(int _IdNhapNhanh, int _NhapHangId)
43 {
44 IdNhapNhanh = _IdNhapNhanh;
45 NhapHangId = _NhapHangId;
46 }
47
48 public NhapNhanhMod(int _IdNhapNhanh, string _MaSanPham, string _MaVietTat, string _TenSanPham, string _TenDonViTinh,double _SoLuong,double _GiaNhap,double _ChietKhau,double _Thue,double _TongTien,int _NhapHangId, string _TrangThai, DateTime _NgayTao)
49 {
50 IdNhapNhanh = _IdNhapNhanh;
51 MaSanPham = _MaSanPham;
52 MaVietTat = _MaVietTat;
53 TenSanPham = _TenSanPham;
54 TenDonViTinh = _TenDonViTinh;
55 SoLuong = _SoLuong;
56 GiaNhap = _GiaNhap;
57 ChietKhau = _ChietKhau;
58 Thue = _Thue;
59 TongTien = _TongTien;
60 NhapHangId = _NhapHangId;
61 TrangThai = _TrangThai;
62 NgayTao = _NgayTao;
63 }
64
65 //Them moi dvt
66 public int InsertNhapNhanh()
67 {
68 int i = 0;
69 string[] paras = new string[13] {"@IdNhapNhanh", "@MaSanPham", "@MaVietTat", "@TenSanPham", "@TenDonViTinh", "@SoLuong", "@GiaNhap", "@ChietKhau", "@Thue", "@TongTien", "@NhapHangId", "@TrangThai", "@NgayTao"};
70 object[] values = new object[13] { IdNhapNhanh, MaSanPham, MaVietTat, TenSanPham, TenDonViTinh, SoLuong, GiaNhap, ChietKhau, Thue, TongTien, NhapHangId, TrangThai, NgayTao };
71 i = Int32.Parse(Models.connection.ExcuteScalar("tbl_NhapNhanh_Insert", CommandType.StoredProcedure, paras, values));
72 return i;
73 }
74
75 public int UpdateNhapNhanh()
76 {
77 int i = 0;
78 string[] paras = new string[13] { "@IdNhapNhanh", "@MaSanPham", "@MaVietTat", "@TenSanPham", "@TenDonViTinh", "@SoLuong", "@GiaNhap", "@ChietKhau", "@Thue", "@TongTien", "@NhapHangId", "@TrangThai", "@NgayTao" };
79 object[] values = new object[13] { IdNhapNhanh, MaSanPham, MaVietTat, TenSanPham, TenDonViTinh, SoLuong, GiaNhap, ChietKhau, Thue, TongTien, NhapHangId, TrangThai, NgayTao };
80 i = Models.connection.Excute_Sql("tbl_NhapNhanh_Update", CommandType.StoredProcedure, paras, values);
81 return i;
82 }
83
84 public int UpdateNhapNhanh_Xoa()
85 {
86 int i = 0;
87 string[] paras = new string[1] { "@IdNhapNhanh"};
88 object[] values = new object[1] { IdNhapNhanh};
89 i = Models.connection.Excute_Sql("tbl_NhapNhanh_Update_Xoa", CommandType.StoredProcedure, paras, values);
90 return i;
91 }
92
93 //delete
94 public int DeleteNhapNhanh()
95 {
96 int i = 0;
97 string[] paras = new string[1] { "@IdNhapNhanh" };
98 object[] values = new object[1] { IdNhapNhanh };
99 i = Models.connection.Excute_Sql("tbl_NhapNhanh_Delete", CommandType.StoredProcedure, paras, values);
100 return i;
101 }
102
103 //xoa tat cac khi an thuc hien
104 public int DeleteNhapNhanh_ByNhapHangId()
105 {
106 int i = 0;
107 string[] paras = new string[2] { "@IdNhapNhanh", "@NhapHangId" };
108 object[] values = new object[2] { IdNhapNhanh, NhapHangId };
109 i = Models.connection.Excute_Sql("tbl_NhapNhanh_Delete_ByNhapHangId", CommandType.StoredProcedure, paras, values);
110 return i;
111 }
112
113 //lấy thông tin trong bảng nhập hàng
114 public DataSet FillDataSet_NhapNhanh_Gets_ByNhapHangId()
115 {
116 DataSet ds = new DataSet();
117 string[] paras = new string[2] {"@IdNhapNhanh", "@NhapHangId" };
118 object[] values = new object[2] { IdNhapNhanh, NhapHangId };
119 ds = Models.connection.FillDataSet("tbl_NhapNhanh_Gets_ByNhapHangId", CommandType.StoredProcedure, paras, values);
120 return ds;
121 }
122 }
123 }